﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSContrato" targetNamespace="http://tempuri.org/DSContrato.xsd" xmlns:mstns="http://tempuri.org/DSContrato.xsd" xmlns="http://tempuri.org/DSContrato.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="DBMatriculaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DBMatriculaConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsApplication1.My.MySettings.GlobalReference.Default.DBMatriculaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SPDadosContratoTableAdapter" GeneratorDataComponentClassName="SPDadosContratoTableAdapter" Name="SPDadosContrato" UserDataComponentName="SPDadosContratoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBMatriculaConnectionString (MySettings)" DbObjectName="DBMatricula.dbo.SPDadosContrato" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SPDadosContrato</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAluno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAluno" DataSetColumn="IDAluno" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Endereco" DataSetColumn="Endereco" />
              <Mapping SourceColumn="Nome1" DataSetColumn="Nome1" />
              <Mapping SourceColumn="RG" DataSetColumn="RG" />
              <Mapping SourceColumn="CPF" DataSetColumn="CPF" />
              <Mapping SourceColumn="DTNascimento" DataSetColumn="DTNascimento" />
              <Mapping SourceColumn="Matricula" DataSetColumn="Matricula" />
              <Mapping SourceColumn="DTCadastro" DataSetColumn="DTCadastro" />
              <Mapping SourceColumn="DDDTelefone" DataSetColumn="DDDTelefone" />
              <Mapping SourceColumn="Telefone" DataSetColumn="Telefone" />
              <Mapping SourceColumn="DDDCelular" DataSetColumn="DDDCelular" />
              <Mapping SourceColumn="Celular" DataSetColumn="Celular" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SPDadosContratoPagamentoTableAdapter" GeneratorDataComponentClassName="SPDadosContratoPagamentoTableAdapter" Name="SPDadosContratoPagamento" UserDataComponentName="SPDadosContratoPagamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBMatriculaConnectionString (MySettings)" DbObjectName="DBMatricula.dbo.SPDadosContratoPagamento" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SPDadosContratoPagamento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAluno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAluno" DataSetColumn="IDAluno" />
              <Mapping SourceColumn="Parcelas" DataSetColumn="Parcelas" />
              <Mapping SourceColumn="Pagamento" DataSetColumn="Pagamento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SPDadosContratoChequeTableAdapter" GeneratorDataComponentClassName="SPDadosContratoChequeTableAdapter" Name="SPDadosContratoCheque" UserDataComponentName="SPDadosContratoChequeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBMatriculaConnectionString (MySettings)" DbObjectName="DBMatricula.dbo.SPDadosContratoCheque" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SPDadosContratoCheque</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAluno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAluno" DataSetColumn="IDAluno" />
              <Mapping SourceColumn="Banco" DataSetColumn="Banco" />
              <Mapping SourceColumn="Agencia" DataSetColumn="Agencia" />
              <Mapping SourceColumn="Conta" DataSetColumn="Conta" />
              <Mapping SourceColumn="NRCheque" DataSetColumn="NRCheque" />
              <Mapping SourceColumn="DTParcela" DataSetColumn="DTParcela" />
              <Mapping SourceColumn="VLParcela" DataSetColumn="VLParcela" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SPDadosContratoEspecificaTableAdapter" GeneratorDataComponentClassName="SPDadosContratoEspecificaTableAdapter" Name="SPDadosContratoEspecifica" UserDataComponentName="SPDadosContratoEspecificaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBMatriculaConnectionString (MySettings)" DbObjectName="DBMatricula.dbo.SPDadosContratoEspecifica" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SPDadosContratoEspecifica</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAluno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAluno" DataSetColumn="IDAluno" />
              <Mapping SourceColumn="IDEspecifica" DataSetColumn="IDEspecifica" />
              <Mapping SourceColumn="DEEspecifica" DataSetColumn="DEEspecifica" />
              <Mapping SourceColumn="Desconto" DataSetColumn="Desconto" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="ResponsavelEspecifica1" DataSetColumn="ResponsavelEspecifica1" />
              <Mapping SourceColumn="CPFResponsavelEspecifica1" DataSetColumn="CPFResponsavelEspecifica1" />
              <Mapping SourceColumn="ResponsavelEspecifica2" DataSetColumn="ResponsavelEspecifica2" />
              <Mapping SourceColumn="CPFResponsavelEspecifica2" DataSetColumn="CPFResponsavelEspecifica2" />
              <Mapping SourceColumn="Assinatura" DataSetColumn="Assinatura" />
              <Mapping SourceColumn="DEEmpresa" DataSetColumn="DEEmpresa" />
              <Mapping SourceColumn="CNPJEmpresa" DataSetColumn="CNPJEmpresa" />
              <Mapping SourceColumn="IEEmpresa" DataSetColumn="IEEmpresa" />
              <Mapping SourceColumn="DataLimiteCancelamento" DataSetColumn="DataLimiteCancelamento" />
              <Mapping SourceColumn="DTInicioAula" DataSetColumn="DTInicioAula" />
              <Mapping SourceColumn="DTFimAula" DataSetColumn="DTFimAula" />
              <Mapping SourceColumn="DTInicioAulaFormat" DataSetColumn="DTInicioAulaFormat" />
              <Mapping SourceColumn="DTFimAulaFormat" DataSetColumn="DTFimAulaFormat" />
              <Mapping SourceColumn="VLCurso" DataSetColumn="VLCurso" />
              <Mapping SourceColumn="DescontoEspecifica" DataSetColumn="DescontoEspecifica" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSContrato" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DSContrato" msprop:Generator_UserDSName="DSContrato">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SPDadosContrato" msprop:Generator_UserTableName="SPDadosContrato" msprop:Generator_RowEvArgName="SPDadosContratoRowChangeEvent" msprop:Generator_TableVarName="tableSPDadosContrato" msprop:Generator_TablePropName="SPDadosContrato" msprop:Generator_RowDeletingName="SPDadosContratoRowDeleting" msprop:Generator_RowChangingName="SPDadosContratoRowChanging" msprop:Generator_RowDeletedName="SPDadosContratoRowDeleted" msprop:Generator_RowEvHandlerName="SPDadosContratoRowChangeEventHandler" msprop:Generator_RowChangedName="SPDadosContratoRowChanged" msprop:Generator_TableClassName="SPDadosContratoDataTable" msprop:Generator_RowClassName="SPDadosContratoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAluno" msprop:Generator_ColumnVarNameInTable="columnIDAluno" msprop:Generator_ColumnPropNameInRow="IDAluno" msprop:Generator_ColumnPropNameInTable="IDAlunoColumn" msprop:Generator_UserColumnName="IDAluno" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Endereco" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEndereco" msprop:Generator_ColumnPropNameInRow="Endereco" msprop:Generator_ColumnPropNameInTable="EnderecoColumn" msprop:Generator_UserColumnName="Endereco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="107" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome1" msprop:Generator_ColumnVarNameInTable="columnNome1" msprop:Generator_ColumnPropNameInRow="Nome1" msprop:Generator_ColumnPropNameInTable="Nome1Column" msprop:Generator_UserColumnName="Nome1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RG" msprop:Generator_ColumnVarNameInTable="columnRG" msprop:Generator_ColumnPropNameInRow="RG" msprop:Generator_ColumnPropNameInTable="RGColumn" msprop:Generator_UserColumnName="RG" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CPF" msprop:Generator_ColumnVarNameInTable="columnCPF" msprop:Generator_ColumnPropNameInRow="CPF" msprop:Generator_ColumnPropNameInTable="CPFColumn" msprop:Generator_UserColumnName="CPF">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTNascimento" msprop:Generator_ColumnVarNameInTable="columnDTNascimento" msprop:Generator_ColumnPropNameInRow="DTNascimento" msprop:Generator_ColumnPropNameInTable="DTNascimentoColumn" msprop:Generator_UserColumnName="DTNascimento" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Matricula" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMatricula" msprop:Generator_ColumnPropNameInRow="Matricula" msprop:Generator_ColumnPropNameInTable="MatriculaColumn" msprop:Generator_UserColumnName="Matricula" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTCadastro" msprop:Generator_ColumnVarNameInTable="columnDTCadastro" msprop:Generator_ColumnPropNameInRow="DTCadastro" msprop:Generator_ColumnPropNameInTable="DTCadastroColumn" msprop:Generator_UserColumnName="DTCadastro" type="xs:dateTime" />
              <xs:element name="DDDTelefone" msprop:Generator_ColumnVarNameInTable="columnDDDTelefone" msprop:Generator_ColumnPropNameInRow="DDDTelefone" msprop:Generator_ColumnPropNameInTable="DDDTelefoneColumn" msprop:Generator_UserColumnName="DDDTelefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefone" msprop:Generator_ColumnVarNameInTable="columnTelefone" msprop:Generator_ColumnPropNameInRow="Telefone" msprop:Generator_ColumnPropNameInTable="TelefoneColumn" msprop:Generator_UserColumnName="Telefone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="9" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DDDCelular" msprop:Generator_ColumnVarNameInTable="columnDDDCelular" msprop:Generator_ColumnPropNameInRow="DDDCelular" msprop:Generator_ColumnPropNameInTable="DDDCelularColumn" msprop:Generator_UserColumnName="DDDCelular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Celular" msprop:Generator_ColumnVarNameInTable="columnCelular" msprop:Generator_ColumnPropNameInRow="Celular" msprop:Generator_ColumnPropNameInTable="CelularColumn" msprop:Generator_UserColumnName="Celular" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="9" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SPDadosContratoPagamento" msprop:Generator_UserTableName="SPDadosContratoPagamento" msprop:Generator_RowEvArgName="SPDadosContratoPagamentoRowChangeEvent" msprop:Generator_TableVarName="tableSPDadosContratoPagamento" msprop:Generator_TablePropName="SPDadosContratoPagamento" msprop:Generator_RowDeletingName="SPDadosContratoPagamentoRowDeleting" msprop:Generator_RowChangingName="SPDadosContratoPagamentoRowChanging" msprop:Generator_RowDeletedName="SPDadosContratoPagamentoRowDeleted" msprop:Generator_RowEvHandlerName="SPDadosContratoPagamentoRowChangeEventHandler" msprop:Generator_RowChangedName="SPDadosContratoPagamentoRowChanged" msprop:Generator_TableClassName="SPDadosContratoPagamentoDataTable" msprop:Generator_RowClassName="SPDadosContratoPagamentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAluno" msprop:Generator_ColumnVarNameInTable="columnIDAluno" msprop:Generator_ColumnPropNameInRow="IDAluno" msprop:Generator_ColumnPropNameInTable="IDAlunoColumn" msprop:Generator_UserColumnName="IDAluno" type="xs:int" />
              <xs:element name="Parcelas" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnParcelas" msprop:Generator_ColumnPropNameInRow="Parcelas" msprop:Generator_ColumnPropNameInTable="ParcelasColumn" msprop:Generator_UserColumnName="Parcelas" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pagamento" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPagamento" msprop:Generator_ColumnPropNameInRow="Pagamento" msprop:Generator_ColumnPropNameInTable="PagamentoColumn" msprop:Generator_UserColumnName="Pagamento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SPDadosContratoCheque" msprop:Generator_UserTableName="SPDadosContratoCheque" msprop:Generator_RowEvArgName="SPDadosContratoChequeRowChangeEvent" msprop:Generator_TableVarName="tableSPDadosContratoCheque" msprop:Generator_TablePropName="SPDadosContratoCheque" msprop:Generator_RowDeletingName="SPDadosContratoChequeRowDeleting" msprop:Generator_RowChangingName="SPDadosContratoChequeRowChanging" msprop:Generator_RowDeletedName="SPDadosContratoChequeRowDeleted" msprop:Generator_RowEvHandlerName="SPDadosContratoChequeRowChangeEventHandler" msprop:Generator_RowChangedName="SPDadosContratoChequeRowChanged" msprop:Generator_TableClassName="SPDadosContratoChequeDataTable" msprop:Generator_RowClassName="SPDadosContratoChequeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAluno" msprop:Generator_ColumnVarNameInTable="columnIDAluno" msprop:Generator_ColumnPropNameInRow="IDAluno" msprop:Generator_ColumnPropNameInTable="IDAlunoColumn" msprop:Generator_UserColumnName="IDAluno" type="xs:int" />
              <xs:element name="Banco" msprop:Generator_ColumnVarNameInTable="columnBanco" msprop:Generator_ColumnPropNameInRow="Banco" msprop:Generator_ColumnPropNameInTable="BancoColumn" msprop:Generator_UserColumnName="Banco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Agencia" msprop:Generator_ColumnVarNameInTable="columnAgencia" msprop:Generator_ColumnPropNameInRow="Agencia" msprop:Generator_ColumnPropNameInTable="AgenciaColumn" msprop:Generator_UserColumnName="Agencia" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conta" msprop:Generator_ColumnVarNameInTable="columnConta" msprop:Generator_ColumnPropNameInRow="Conta" msprop:Generator_ColumnPropNameInTable="ContaColumn" msprop:Generator_UserColumnName="Conta" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NRCheque" msprop:Generator_ColumnVarNameInTable="columnNRCheque" msprop:Generator_ColumnPropNameInRow="NRCheque" msprop:Generator_ColumnPropNameInTable="NRChequeColumn" msprop:Generator_UserColumnName="NRCheque" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTParcela" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDTParcela" msprop:Generator_ColumnPropNameInRow="DTParcela" msprop:Generator_ColumnPropNameInTable="DTParcelaColumn" msprop:Generator_UserColumnName="DTParcela" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VLParcela" msprop:Generator_ColumnVarNameInTable="columnVLParcela" msprop:Generator_ColumnPropNameInRow="VLParcela" msprop:Generator_ColumnPropNameInTable="VLParcelaColumn" msprop:Generator_UserColumnName="VLParcela" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SPDadosContratoEspecifica" msprop:Generator_TableClassName="SPDadosContratoEspecificaDataTable" msprop:Generator_RowEvArgName="SPDadosContratoEspecificaRowChangeEvent" msprop:Generator_TableVarName="tableSPDadosContratoEspecifica" msprop:Generator_TablePropName="SPDadosContratoEspecifica" msprop:Generator_RowDeletingName="SPDadosContratoEspecificaRowDeleting" msprop:Generator_UserTableName="SPDadosContratoEspecifica" msprop:Generator_RowChangingName="SPDadosContratoEspecificaRowChanging" msprop:Generator_RowDeletedName="SPDadosContratoEspecificaRowDeleted" msprop:Generator_RowChangedName="SPDadosContratoEspecificaRowChanged" msprop:Generator_RowEvHandlerName="SPDadosContratoEspecificaRowChangeEventHandler" msprop:Generator_RowClassName="SPDadosContratoEspecificaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAluno" msprop:Generator_ColumnVarNameInTable="columnIDAluno" msprop:Generator_ColumnPropNameInRow="IDAluno" msprop:Generator_ColumnPropNameInTable="IDAlunoColumn" msprop:Generator_UserColumnName="IDAluno" type="xs:int" />
              <xs:element name="IDEspecifica" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnIDEspecifica" msprop:Generator_ColumnPropNameInRow="IDEspecifica" msprop:Generator_ColumnPropNameInTable="IDEspecificaColumn" msprop:Generator_UserColumnName="IDEspecifica" type="xs:int" />
              <xs:element name="DEEspecifica" msprop:Generator_ColumnVarNameInTable="columnDEEspecifica" msprop:Generator_ColumnPropNameInRow="DEEspecifica" msprop:Generator_ColumnPropNameInTable="DEEspecificaColumn" msprop:Generator_UserColumnName="DEEspecifica">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Desconto" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDesconto" msprop:Generator_ColumnPropNameInRow="Desconto" msprop:Generator_ColumnPropNameInTable="DescontoColumn" msprop:Generator_UserColumnName="Desconto" type="xs:decimal" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" />
              <xs:element name="ResponsavelEspecifica1" msprop:Generator_ColumnVarNameInTable="columnResponsavelEspecifica1" msprop:Generator_ColumnPropNameInRow="ResponsavelEspecifica1" msprop:Generator_ColumnPropNameInTable="ResponsavelEspecifica1Column" msprop:Generator_UserColumnName="ResponsavelEspecifica1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CPFResponsavelEspecifica1" msprop:Generator_ColumnVarNameInTable="columnCPFResponsavelEspecifica1" msprop:Generator_ColumnPropNameInRow="CPFResponsavelEspecifica1" msprop:Generator_ColumnPropNameInTable="CPFResponsavelEspecifica1Column" msprop:Generator_UserColumnName="CPFResponsavelEspecifica1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResponsavelEspecifica2" msprop:Generator_ColumnVarNameInTable="columnResponsavelEspecifica2" msprop:Generator_ColumnPropNameInRow="ResponsavelEspecifica2" msprop:Generator_ColumnPropNameInTable="ResponsavelEspecifica2Column" msprop:Generator_UserColumnName="ResponsavelEspecifica2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CPFResponsavelEspecifica2" msprop:Generator_ColumnVarNameInTable="columnCPFResponsavelEspecifica2" msprop:Generator_ColumnPropNameInRow="CPFResponsavelEspecifica2" msprop:Generator_ColumnPropNameInTable="CPFResponsavelEspecifica2Column" msprop:Generator_UserColumnName="CPFResponsavelEspecifica2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Assinatura" msprop:Generator_ColumnVarNameInTable="columnAssinatura" msprop:Generator_ColumnPropNameInRow="Assinatura" msprop:Generator_ColumnPropNameInTable="AssinaturaColumn" msprop:Generator_UserColumnName="Assinatura" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="DEEmpresa" msprop:Generator_ColumnVarNameInTable="columnDEEmpresa" msprop:Generator_ColumnPropNameInRow="DEEmpresa" msprop:Generator_ColumnPropNameInTable="DEEmpresaColumn" msprop:Generator_UserColumnName="DEEmpresa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CNPJEmpresa" msprop:Generator_ColumnVarNameInTable="columnCNPJEmpresa" msprop:Generator_ColumnPropNameInRow="CNPJEmpresa" msprop:Generator_ColumnPropNameInTable="CNPJEmpresaColumn" msprop:Generator_UserColumnName="CNPJEmpresa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="14" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IEEmpresa" msprop:Generator_ColumnVarNameInTable="columnIEEmpresa" msprop:Generator_ColumnPropNameInRow="IEEmpresa" msprop:Generator_ColumnPropNameInTable="IEEmpresaColumn" msprop:Generator_UserColumnName="IEEmpresa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataLimiteCancelamento" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDataLimiteCancelamento" msprop:Generator_ColumnPropNameInRow="DataLimiteCancelamento" msprop:Generator_ColumnPropNameInTable="DataLimiteCancelamentoColumn" msprop:Generator_UserColumnName="DataLimiteCancelamento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTInicioAula" msprop:Generator_ColumnVarNameInTable="columnDTInicioAula" msprop:Generator_ColumnPropNameInRow="DTInicioAula" msprop:Generator_ColumnPropNameInTable="DTInicioAulaColumn" msprop:Generator_UserColumnName="DTInicioAula" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DTFimAula" msprop:Generator_ColumnVarNameInTable="columnDTFimAula" msprop:Generator_ColumnPropNameInRow="DTFimAula" msprop:Generator_ColumnPropNameInTable="DTFimAulaColumn" msprop:Generator_UserColumnName="DTFimAula" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DTInicioAulaFormat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDTInicioAulaFormat" msprop:Generator_ColumnPropNameInRow="DTInicioAulaFormat" msprop:Generator_ColumnPropNameInTable="DTInicioAulaFormatColumn" msprop:Generator_UserColumnName="DTInicioAulaFormat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTFimAulaFormat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDTFimAulaFormat" msprop:Generator_ColumnPropNameInRow="DTFimAulaFormat" msprop:Generator_ColumnPropNameInTable="DTFimAulaFormatColumn" msprop:Generator_UserColumnName="DTFimAulaFormat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VLCurso" msprop:Generator_ColumnVarNameInTable="columnVLCurso" msprop:Generator_ColumnPropNameInRow="VLCurso" msprop:Generator_ColumnPropNameInTable="VLCursoColumn" msprop:Generator_UserColumnName="VLCurso" type="xs:decimal" minOccurs="0" />
              <xs:element name="DescontoEspecifica" msprop:Generator_ColumnVarNameInTable="columnDescontoEspecifica" msprop:Generator_ColumnPropNameInRow="DescontoEspecifica" msprop:Generator_ColumnPropNameInTable="DescontoEspecificaColumn" msprop:Generator_UserColumnName="DescontoEspecifica" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="SPDadosContratoKey1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SPDadosContrato" />
      <xs:field xpath="mstns:IDAluno" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="SPDadosContrato_SPDadosContratoPagamento" msdata:parent="SPDadosContrato" msdata:child="SPDadosContratoPagamento" msdata:parentkey="IDAluno" msdata:childkey="IDAluno" msprop:Generator_UserChildTable="SPDadosContratoPagamento" msprop:Generator_ChildPropName="GetSPDadosContratoPagamentoRows" msprop:Generator_ParentPropName="SPDadosContratoRow" msprop:Generator_UserRelationName="SPDadosContrato_SPDadosContratoPagamento" msprop:Generator_RelationVarName="relationSPDadosContrato_SPDadosContratoPagamento" msprop:Generator_UserParentTable="SPDadosContrato" />
      <msdata:Relationship name="SPDadosContrato_SPDadosContratoCheque" msdata:parent="SPDadosContrato" msdata:child="SPDadosContratoCheque" msdata:parentkey="IDAluno" msdata:childkey="IDAluno" msprop:Generator_UserChildTable="SPDadosContratoCheque" msprop:Generator_ChildPropName="GetSPDadosContratoChequeRows" msprop:Generator_ParentPropName="SPDadosContratoRow" msprop:Generator_UserRelationName="SPDadosContrato_SPDadosContratoCheque" msprop:Generator_RelationVarName="relationSPDadosContrato_SPDadosContratoCheque" msprop:Generator_UserParentTable="SPDadosContrato" />
      <msdata:Relationship name="SPDadosContrato_SPDadosContratoEspecifica" msdata:parent="SPDadosContrato" msdata:child="SPDadosContratoEspecifica" msdata:parentkey="IDAluno" msdata:childkey="IDAluno" msprop:Generator_UserChildTable="SPDadosContratoEspecifica" msprop:Generator_ChildPropName="GetSPDadosContratoEspecificaRows" msprop:Generator_ParentPropName="SPDadosContratoRow" msprop:Generator_UserRelationName="SPDadosContrato_SPDadosContratoEspecifica" msprop:Generator_RelationVarName="relationSPDadosContrato_SPDadosContratoEspecifica" msprop:Generator_UserParentTable="SPDadosContrato" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>